<?php
class QUtility
{	
	public function __construct($p_strCountry)
	{
		$this->_country	= $p_strCountry;
		$this->_db		= new Common_Db('wms_'.$this->_country);
	}
	
	function __destruct() 
	{
		$this->_db->closeConnection();
	}
	
	
	public static function showTablesOnDatabase()
	{
		$strQuery= "show tables;";				
        $arrData = $this->_db->fetchAll($strQuery);     
        return  $arrData;                 
	}
	
	public static function showConlumnOnTable()
	{
		$table="vi_tooltips";
		
		$strQuery= "SHOW COLUMNS FROM " . $table .";";				
		$arrData = $this->_db->fetchAll($strQuery);     		
		return  $arrData;                 
	}
}
?>